﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
using System.Collections.Generic;
using IronSuit.Utility;

namespace IronSuit.Crazy250Web
{
	public partial class _Default : System.Web.UI.Page
	{
		protected void Page_Load(object sender, EventArgs e)
		{
			Dictionary<string, string> InputDic = new Dictionary<string, string>();
			InputDic["yy"] = "33";
			InputDic["yy1"] = "33";
			string tt=JSONHelper.ToJson<Dictionary<string, string>>(InputDic);
			string sqlstr = "select * from Crazy_People";

			MySqlConnection DBConn = new MySqlConnection("Database=crazy250;Data Source=127.0.0.1;User Id=root;Password=chen82");
			DBConn.Open();
			//MySQLDataAdapter myadap = new MySQLDataAdapter(sqlstr, conn);
			MySqlCommand DBComm = new MySqlCommand(sqlstr, DBConn);
			//MySQLDataReader DBReader = DBComm.ExecuteReaderEx(); //DBComm.ExecuteReaderEx();
			MySqlDataAdapter DTAdapter = new MySqlDataAdapter(sqlstr, DBConn);

			DataSet myDataSet = new DataSet();
			DTAdapter.Fill(myDataSet, "manavatar");
		}
	}
}
